[dbo].[LicenseMap]

Property	Value
Created	10:31:26 AM Tuesday, March 02, 2010
Last Modified	11:40:03 AM Monday, February 20, 2012

Property

Value

Created

10:31:26 AM Tuesday, March 02, 2010

Last Modified

11:40:03 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_LicenseMap: LicenseKey\LicenseType$	LicenseKey	uniqueidentifier	16
$Cluster Primary Key PK_LicenseMap: LicenseKey\LicenseType$	LicenseType	nvarchar(100)	200
	MarkedForDeleteOn	datetime	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_LicenseMap: LicenseKey\LicenseType$

LicenseKey

uniqueidentifier

$Cluster Primary Key PK_LicenseMap: LicenseKey\LicenseType$

LicenseType

nvarchar(100)

200

MarkedForDeleteOn

datetime

	Name	Columns	Unique
$Cluster Primary Key PK_LicenseMap: LicenseKey\LicenseType$	PK_LicenseMap	LicenseKey, LicenseType

Name

Columns

Unique

$Cluster Primary Key PK_LicenseMap: LicenseKey\LicenseType$

PK_LicenseMap

LicenseKey, LicenseType

Name	Columns
FK_LicenseMap_License	LicenseKey->[dbo].[License].[LicenseKey]
FK_LicenseMap_LicenseTypeRef	LicenseType->[dbo].[LicenseTypeRef].[LicenseType]

Name

Columns

FK_LicenseMap_License

LicenseKey->[dbo].[License].[LicenseKey]

FK_LicenseMap_LicenseTypeRef

LicenseType->[dbo].[LicenseTypeRef].[LicenseType]

SQL Script

CREATE TABLE [dbo].[LicenseMap]
(
[LicenseKey] [uniqueidentifier] NOT NULL,
[LicenseType] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[LicenseMap] ADD CONSTRAINT [PK_LicenseMap] PRIMARY KEY CLUSTERED ([LicenseKey], [LicenseType]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[LicenseMap] ADD CONSTRAINT [FK_LicenseMap_License] FOREIGN KEY ([LicenseKey]) REFERENCES [dbo].[License] ([LicenseKey])
GO
ALTER TABLE [dbo].[LicenseMap] ADD CONSTRAINT [FK_LicenseMap_LicenseTypeRef] FOREIGN KEY ([LicenseType]) REFERENCES [dbo].[LicenseTypeRef] ([LicenseType])
GO